2013-04-10 - 5910.200 - Rel Notes - Contracts - Release 017 #BIReleases2013
Release Notes:
5910.200 - Contracts - EPM200
Admin Info
Purpose
|
Including Contract Information in EPM200 - Customer Scorecard
|
Release No
|
017
|
Submitted
|
04-10-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Narendra Koraganji
|
Object(s) Tested By
|
Narendra Koraganji
|
Report Name
EPM200 - Customer Scorecard
BEx Query
ZMP_OPASA_Q001
ZMP_OPASA_Q002
ZMP_OPASA_Q003
ZMP_OPASA_Q004
ZMP_OPASA_Q005
ZMP_OPASA_Q006
ZMP_OPASA_Q007
ZMP_OPASA_Q008
ZMP_OPASA_Q009
ZMP_OPASA_Q010
ZMP_OPASA_Q011
ZMP_OPASA_Q012
NEC Crystal Reports Standards Check
1. EPM200 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. EPM200 NEC CR checklist has been sent to NEC and also attached here for reference:
EPM200 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
Group: North America
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Current Year Shipped YTD
|
65,895,548
|
65,895,548
|
Pass
|
2
|
Last Year Shipped YTD
|
49,535,432
|
49,535,432
|
Pass
|
3
|
Current Year Budget YTD
|
81,480,846
|
81,480,846
|
Pass
|
4
|
Total Open Revenue
|
128,132,426
|
128,132,426
|
Pass
|
5
|
Total Shipped Current Year
|
194,027,973
|
194,027,973
|
Pass
|
6
|
Total Shipped Last Year
|
447,596,834
|
447,596,834
|
Pass
|
7
|
Total Budget Current Year
|
516,707,703
|
516,707,703
|
Pass
|
8
|
TY Quantity
|
5,913,844
|
5,913,844
|
Pass
|
9
|
LY Quantity
|
4,735,464
|
4,735,464
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Product Mix Subreport : Headwear
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Current Year Shipped YTD
|
58,189,876
|
58,189,876
|
Pass
|
2
|
Open
|
110,926,270
|
110,926,270
|
Pass
|
3
|
Total Revenue YTD
|
169,116,146
|
169,116,146
|
Pass
|
4
|
Last Year Shipped YTD
|
49,414,043
|
49,414,043
|
Pass
|
5
|
Current Year Budget YTD
|
71,549,289
|
71,549,289
|
Pass
|
6
|
TY Quantity
|
5,072,270
|
5,072,270
|
Pass
|
7
|
LY Quantity
|
4,726,020
|
4,726,020
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
License Subreport : MLB Properties
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
36,077,617
|
36,077,617
|
Pass
|
2
|
Open
|
40,517,831
|
40,517,831
|
Pass
|
3
|
Total
|
76,595,447
|
76,595,447
|
Pass
|
4
|
Last Year
|
30,673,492
|
30,673,492
|
Pass
|
5
|
Budget
|
41,006,366
|
41,006,366
|
Pass
|
6
|
TY Quantity
|
3,041,465
|
3,041,465
|
Pass
|
7
|
LY Quantity
|
2,539,906
|
2,539,906
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Customer Segment Subreport : TASTEMAKER
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Current Year Shipped YTD
|
471,637
|
471,637
|
Pass
|
2
|
Open
|
624,915
|
624,915
|
Pass
|
3
|
Total Revenue YTD
|
1,096,552
|
1,096,552
|
Pass
|
4
|
Last Year Shipped YTD
|
212,261
|
212,261
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
37,264
|
37,264
|
Pass
|
7
|
LY Quantity
|
15,650
|
15,650
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Silhouette Subreport : 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
31,047,681
|
31,047,681
|
Pass
|
2
|
Open
|
39,696,017
|
39,696,017
|
Pass
|
3
|
Total
|
70,743,699
|
70,743,699
|
Pass
|
4
|
Last Year
|
28,811,657
|
28,811,657
|
Pass
|
5
|
Budget
|
38,980,491
|
38,980,491
|
Pass
|
6
|
TY Quantity
|
2,106,764
|
2,106,764
|
Pass
|
7
|
LY Quantity
|
2,304,102
|
2,304,102
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Collection Subreport : CUSTOM
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
14,315,104
|
14,315,104
|
Pass
|
2
|
Open
|
38,401,326
|
38,401,326
|
Pass
|
3
|
Total
|
52,716,430
|
52,716,430
|
Pass
|
4
|
Last Year
|
10,890,258
|
10,890,258
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
1,880,401
|
1,880,401
|
Pass
|
7
|
LY Quantity
|
1,490,916
|
1,490,916
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Current Month Reports:
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Current Year Shipped MTD
|
42,158,008
|
42,158,008
|
Pass
|
2
|
Last Year Shipped MTD
|
34,323,003
|
34,323,003
|
Pass
|
3
|
Budget Current Year MTD
|
0
|
0
|
Pass
|
4
|
TY Quantity Current Year MTD
|
3,649,036
|
3,649,036
|
Pass
|
5
|
LY Quantity Last Year MTD
|
3,201,655
|
3,201,655
|
Pass
|
6
|
Budget Quantity Current Year MTD
|
0
|
0
|
Pass
|
Product Mix Month Subreport : Accessories
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Current Year Shipped YTD
|
152,138
|
152,138
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue YTD
|
152,138
|
152,138
|
Pass
|
4
|
Last Year Shipped YTD
|
47,616
|
47,616
|
Pass
|
5
|
Current Year Budget YTD
|
64,700
|
64,700
|
Pass
|
6
|
TY Quantity
|
12,579
|
12,579
|
Pass
|
7
|
LY Quantity
|
4,691
|
4,691
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
License Month Subreport : NBA Properties
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
4,819,412
|
4,819,412
|
Pass
|
2
|
Open
|
170,574
|
170,574
|
Pass
|
3
|
Total
|
4,989,986
|
4,989,986
|
Pass
|
4
|
Last Year
|
4,152,066
|
4,152,066
|
Pass
|
5
|
Budget
|
3,102,811
|
3,102,811
|
Pass
|
6
|
TY Quantity
|
410,101
|
410,101
|
Pass
|
7
|
LY Quantity
|
362,021
|
362,021
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Customer Segment Month Subreport : GOLDSTAR - MTD
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Current Year Shipped YTD
|
1,401,306
|
1,401,306
|
Pass
|
2
|
Open
|
0
|
0
|
Pass
|
3
|
Total Revenue YTD
|
1,401,306
|
1,401,306
|
Pass
|
4
|
Last Year Shipped YTD
|
1,629,535
|
1,629,535
|
Pass
|
5
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
106,094
|
106,094
|
Pass
|
7
|
LY Quantity
|
119,117
|
119,117
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Silhouette Month Subreport : 3930
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
5,589,304
|
5,589,304
|
Pass
|
2
|
Open
|
1,775
|
1,775
|
Pass
|
3
|
Total
|
5,591,079
|
5,591,079
|
Pass
|
4
|
Last Year
|
3,983,225
|
3,983,225
|
Pass
|
5
|
Budget
|
7,235,165
|
7,235,165
|
Pass
|
8
|
TY Quantity
|
547,081
|
547,081
|
Pass
|
9
|
LY Quantity
|
491,967
|
491,967
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Collection Month Subreport : CUSTOM 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
4,364,304
|
4,364,304
|
Pass
|
2
|
Open
|
13,677
|
13,677
|
Pass
|
3
|
Total
|
4,377,982
|
4,377,982
|
Pass
|
4
|
Last Year
|
4,253,290
|
4,253,290
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
8
|
TY Quantity
|
337,462
|
337,462
|
Pass
|
9
|
LY Quantity
|
333,224
|
333,224
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Second Level Check
Test Conducted
Group: North America > CHAMPS DIVISION
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Current Year Shipped YTD
|
3,090,669
|
3,090,669
|
Pass
|
2
|
Last Year Shipped YTD
|
5,785,615
|
5,785,615
|
Pass
|
3
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
4
|
Total Open Revenue
|
2,671,363
|
2,671,363
|
Pass
|
5
|
Total Shipped Current Year
|
5762032
|
5,762,032
|
Pass
|
6
|
Total Shipped Last Year
|
16,226,932
|
16,226,932
|
Pass
|
7
|
Total Budget Current Year
|
0
|
0
|
Pass
|
8
|
TY Quantity
|
246,065
|
246,065
|
Pass
|
9
|
LY Quantity
|
468,151
|
468,151
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Product Mix Subreport : Headwear
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
3,090,669
|
3,090,669
|
Pass
|
2
|
Open
|
2,671,363
|
2,671,363
|
Pass
|
3
|
Total
|
5,762,032
|
5,762,032
|
Pass
|
4
|
Last Year
|
5,785,615
|
5,785,615
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
246,065
|
246,065
|
Pass
|
7
|
LY Quantity
|
468,151
|
468,151
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Customer Segment Subreport : NATIONAL KEY ACCOUNTS
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
3,090,669
|
3,090,669
|
Pass
|
2
|
Open
|
2,671,363
|
2,671,363
|
Pass
|
3
|
Total
|
5,762,032
|
5,762,032
|
Pass
|
4
|
Last Year
|
5,785,615
|
5,785,615
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
246,065
|
246,065
|
Pass
|
7
|
LY Quantity
|
468,151
|
468,151
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
License Subreport : MLB Properties
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
2,223,890
|
2,223,890
|
Pass
|
2
|
Open
|
862,052
|
862,052
|
Pass
|
3
|
Total
|
3,085,943
|
3,085,943
|
Pass
|
4
|
Last Year
|
3,439,459
|
3,439,459
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
176,006
|
176,006
|
Pass
|
7
|
LY Quantity
|
269,024
|
269,024
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Silhouette Subreport : 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
2,264,658
|
2,264,658
|
Pass
|
2
|
Open
|
782,036
|
782,036
|
Pass
|
3
|
Total
|
3,046,694
|
3,046,694
|
Pass
|
4
|
Last Year
|
3,501,628
|
3,501,628
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
164,797
|
164,797
|
Pass
|
7
|
LY Quantity
|
252,923
|
252,923
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Collection Subreport : CUSTOM 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
450,684
|
450,684
|
Pass
|
2
|
Open
|
204,990
|
204,990
|
Pass
|
3
|
Total
|
655,674
|
655,674
|
Pass
|
4
|
Last Year
|
883,736
|
883,736
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
32,481
|
32,481
|
Pass
|
7
|
LY Quantity
|
63,444
|
63,444
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Current Month Reports:
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Current Year Shipped MTD
|
1,024,478
|
1,024,478
|
Pass
|
2
|
Last Year Shipped MTD
|
1,996,271
|
1,996,271
|
Pass
|
3
|
Budget Current Year MTD
|
0
|
0
|
Pass
|
4
|
TY Quantity Current Year MTD
|
86,633
|
86,633
|
Pass
|
5
|
LY Quantity Last Year MTD
|
166,993
|
166,993
|
Pass
|
6
|
Budget Quantity Current Year MTD
|
0
|
0
|
Pass
|
Product Mix Month Subreport : Headwear
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
1,024,478
|
1,024,478
|
Pass
|
2
|
Open
|
506,927
|
506,927
|
Pass
|
3
|
Total
|
1,531,405
|
1,531,405
|
Pass
|
4
|
Last Year
|
1,996,271
|
1,996,271
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
86,633
|
86,633
|
Pass
|
7
|
LY Quantity
|
166,993
|
166,993
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Customer Segment Month Subreport : NATIONAL KEY ACCOUNTS
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
1,024,478
|
1,024,478
|
Pass
|
2
|
Open
|
506,927
|
506,927
|
Pass
|
3
|
Total
|
1,531,405
|
1,531,405
|
Pass
|
4
|
Last Year
|
1,996,271
|
1,996,271
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
86,633
|
86,633
|
Pass
|
7
|
LY Quantity
|
166,993
|
166,993
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
License Month Subreport : NBA Properties
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
111,299
|
111,299
|
Pass
|
2
|
Open
|
185,686
|
185,686
|
Pass
|
3
|
Total
|
296,985
|
296,985
|
Pass
|
4
|
Last Year
|
258,632
|
258,632
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
8,785
|
8,785
|
Pass
|
7
|
LY Quantity
|
22,613
|
22,613
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Silhouette Month Subreport : 950
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
204,284
|
204,284
|
Pass
|
2
|
Open
|
137,894
|
137,894
|
Pass
|
3
|
Total
|
342,178
|
342,178
|
Pass
|
4
|
Last Year
|
893,893
|
893,893
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
8
|
TY Quantity
|
18,424
|
18,424
|
Pass
|
9
|
LY Quantity
|
80,208
|
80,208
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Collection Month Subreport : CUSTOM 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
146,790
|
146,790
|
Pass
|
2
|
Open
|
130,284
|
130,284
|
Pass
|
3
|
Total
|
277,074
|
277,074
|
Pass
|
4
|
Last Year
|
68,880
|
68,880
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
8
|
TY Quantity
|
10,485
|
10,485
|
Pass
|
9
|
LY Quantity
|
4,920
|
4,920
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Third Level Check
Test Conducted
Group: North America > CHAMPS DIVISION > United States Sales
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Current Year Shipped YTD
|
3,090,669
|
3,090,669
|
Pass
|
2
|
Last Year Shipped YTD
|
5,785,615
|
5,785,615
|
Pass
|
3
|
Current Year Budget YTD
|
0
|
0
|
Pass
|
4
|
Total Open Revenue
|
2,671,363
|
2,671,363
|
Pass
|
5
|
Total Shipped Current Year
|
5,762,032
|
5,762,032
|
Pass
|
6
|
Total Shipped Last Year
|
16,226,932
|
16,226,932
|
Pass
|
7
|
Total Budget Current Year
|
0
|
0
|
Pass
|
8
|
TY Quantity
|
246,065
|
246,065
|
Pass
|
9
|
LY Quantity
|
468,151
|
468,151
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Product Mix Subreport : Headwear
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
3,090,669
|
3,090,669
|
Pass
|
2
|
Open
|
2,671,363
|
2,671,363
|
Pass
|
3
|
Total
|
5,762,032
|
5,762,032
|
Pass
|
4
|
Last Year
|
5,785,615
|
5,785,615
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
246,065
|
246,065
|
Pass
|
7
|
LY Quantity
|
468,151
|
468,151
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Customer Segment Subreport : NATIONAL KEY ACCOUNTS
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
3,090,669
|
3,090,669
|
Pass
|
2
|
Open
|
2,671,363
|
2,671,363
|
Pass
|
3
|
Total
|
5,762,032
|
5,762,032
|
Pass
|
4
|
Last Year
|
5,785,615
|
5,785,615
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
246,065
|
246,065
|
Pass
|
7
|
LY Quantity
|
468,151
|
468,151
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
License Subreport : MLB Properties
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
2,223,890
|
2,223,890
|
Pass
|
2
|
Open
|
862,052
|
862,052
|
Pass
|
3
|
Total
|
3,085,943
|
3,085,943
|
Pass
|
4
|
Last Year
|
3,439,459
|
3,439,459
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
176,006
|
176,006
|
Pass
|
7
|
LY Quantity
|
269,024
|
269,024
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Silhouette Subreport : 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
2,264,658
|
2,264,658
|
Pass
|
2
|
Open
|
782,036
|
782,036
|
Pass
|
3
|
Total
|
3,046,694
|
3,046,694
|
Pass
|
4
|
Last Year
|
3,501,628
|
3,501,628
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
164,797
|
164,797
|
Pass
|
7
|
LY Quantity
|
252,923
|
252,923
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Collection Subreport : CUSTOM 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
450,684
|
450,684
|
Pass
|
2
|
Open
|
204,990
|
204,990
|
Pass
|
3
|
Total
|
655,674
|
655,674
|
Pass
|
4
|
Last Year
|
883,736
|
883,736
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
32,481
|
32,481
|
Pass
|
7
|
LY Quantity
|
63,444
|
63,444
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Current Month Reports:
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Current Year Shipped MTD
|
1,024,478
|
1,024,478
|
Pass
|
2
|
Last Year Shipped MTD
|
1,996,271
|
1,996,271
|
Pass
|
3
|
Budget Current Year MTD
|
0
|
0
|
Pass
|
4
|
TY Quantity Current Year MTD
|
86,633
|
86,633
|
Pass
|
5
|
LY Quantity Last Year MTD
|
166,993
|
166,993
|
Pass
|
6
|
Budget Quantity Current Year MTD
|
0
|
0
|
Pass
|
Product Mix Month Subreport : Headwear
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
1,024,478
|
1,024,478
|
Pass
|
2
|
Open
|
506,927
|
506,927
|
Pass
|
3
|
Total
|
1,531,405
|
1,531,405
|
Pass
|
4
|
Last Year
|
1,996,271
|
1,996,271
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
86,633
|
86,633
|
Pass
|
7
|
LY Quantity
|
166,993
|
166,993
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Customer Segment Month Subreport : NATIONAL KEY ACCOUNTS
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
1,024,478
|
1,024,478
|
Pass
|
2
|
Open
|
506,927
|
506,927
|
Pass
|
3
|
Total
|
1,531,405
|
1,531,405
|
Pass
|
4
|
Last Year
|
1,996,271
|
1,996,271
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
86633
|
86,633
|
Pass
|
7
|
LY Quantity
|
166,993
|
166,993
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
License Month Subreport : NBA Properties
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
111,299
|
111,299
|
Pass
|
2
|
Open
|
185,686
|
185,686
|
Pass
|
3
|
Total
|
296,985
|
296,985
|
Pass
|
4
|
Last Year
|
258,632
|
258,632
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
6
|
TY Quantity
|
8,785
|
8,785
|
Pass
|
7
|
LY Quantity
|
22,613
|
22,613
|
Pass
|
8
|
Budget Quantity
|
0
|
0
|
Pass
|
Silhouette Month Subreport : 950
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
204,284
|
204,284
|
Pass
|
2
|
Open
|
137,894
|
137,894
|
Pass
|
3
|
Total
|
342,178
|
342,178
|
Pass
|
4
|
Last Year
|
893,893
|
893,893
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
8
|
TY Quantity
|
18,424
|
18,424
|
Pass
|
9
|
LY Quantity
|
80,208
|
80,208
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Collection Month Subreport : CUSTOM 5950
SNo
|
Test Case
|
Value in CR
|
Value in BEx/Budget Sheet
|
Pass/Fail Criteria
|
1
|
Shipped
|
146,790
|
146,790
|
Pass
|
2
|
Open
|
130,284
|
130,284
|
Pass
|
3
|
Total
|
277,074
|
277,074
|
Pass
|
4
|
Last Year
|
68,880
|
68,880
|
Pass
|
5
|
Budget
|
0
|
0
|
Pass
|
8
|
TY Quantity
|
10,485
|
10,485
|
Pass
|
9
|
LY Quantity
|
4,920
|
4,920
|
Pass
|
10
|
Budget Quantity
|
0
|
0
|
Pass
|
Reference Document(Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports